Stored Procedures [dbo].[BAEOrderAttributeUpdate]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderAttributeUpdate
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@OrderAttributeIdint4
@Codevarchar(128)128
@Titlevarchar(128)128
@Descriptionvarchar(1024)1024
SQL Script
create procedure [dbo].[BAEOrderAttributeUpdate] @OrderAttributeId as
int,
    @Code AS varchar(128),
    @Title AS varchar(128),
    @Description AS varchar(1024)
AS
    UPDATE OrderSuperProductAttribute
    SET
    Code = @Code, Title = @Title, Description = @Description
    WHERE OrderSuperProductAttributeID = @OrderAttributeId;

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved